Regex - Find the word that has FF in part of it

[MahmudSaniat]

Hi,

I have a string with multiple words, and trying to identify the word with FF in it.

E.g. "I am a FFN customer" - from this string I want to create a column with value FFN.

Thanks for the help.

[MilindG]

[MahmudSaniat]

Hi,

Thanks for the attempt.

Perhaps we are only few inches away ...

There is no guarantee that the word will be in this format:

FFN, FFT

it can be GFF, HFF33 etc.

Thanks

[mceleavey]

Hi @MahmudSaniat ,

if you provide some representative data we can build some different methods depending on how your data is structured.

M.

[MahmudSaniat]

Hi,

I have data in this format:

RandomWords<optional space>RandomLetersFFRandomLetters<optional space>RandomWords

I want to fetch the last letter before FF together with the FF ... like:

FARHAN SFF --> SFF
ASIF PFF96 --> PFF


Thanks for the help.

[Emmanuel_G · Accepted solution]

@MahmudSaniat 

Find in attachement a way of doing that.