pattern match

Answered

Follow

Mallinath

• September 12, 2019 15:06

i am looking for pattern match where my values of coulm A and B are as below.

A                                                                          B

FIRE AND RESCUE SERVICE	FIRE STATION
FIRE BRIGADE HQ STATION	FIRE STATION

WARE STATION

WARE TRAIN STATION

like wise should match even if partial match how we can match records.

Please let me know what best i can do.

thanks..

0

• Official comment

  

  Alan

  • October 30, 2019 18:00
  • Edited

  Hi Mallinath,

  Can you please clarify what you want your result to be if the strings meet the match criteria?

  Is there going to be a third column providing the terms for matching?

  Will the first word in column A always be the match term?  If it is an option is to split the first word using our SPLIT function.  

  Other functions which may be helpful here are CONTAINS, CONTAINS_IC, MATCHES.

  If you provide some additional detail on the column data and what you're trying to achieve with the matching - we may be able to provide some more specific guidance.

  Comment actions Permalink

Please sign in to leave a comment.