Extract number adjacent to String
Hi, can anybody help me to extract numbers adjacent to strings?I have column1 shown below, and expect to extract numbers adjacent to "HFA" (column2). I tried the following JSL, but could not get column2 that I expectNum( Regex( :Column 1, "(\d\d\d)HFA | HFA(\d\d\d)", "\1" ) ) column1column2400HFA isa300400isa300 HFA400400 Thank you for considering the question.