Conditional Statement

[Hi2023]

so I have a column named Filename and it has the email file path along imbedded with the system for that record but i need to create I think, a conditional statement to add a new column for each system. Correct? So its a V_WString with a email path embedded w system name like this: filename_FGG_system -I need to identify the FGG out of it to be able to create what I need? There is 4 different systems total.

thanks

[grazitti_sapna]

Hey @Hi2023 , Not sure if I get your requirement completely. But here is my solution as per my understanding. You can us a formula tool and regex to extract FGG part from the path. Let me know if it was helpful.

[KrishnaChithrathil]

Hola @Hi2023 

Do you wanna extract system name outta it? You can also do it with Regex tool.

[Hi2023]

so this is the4 dummy email paith for the filename, would it still be the same when using reglex?

D:\Users\123456\Downloads\JYC\Dups files\FGG\FOOOBasePhotoIngest_Upload_DTP_FGG_File1_2022-09-17 123456.xlsx

I need the FGG only out

thanks!

[ShankerV]

@Hi2023 

Can you explain elaborately with sample input and output expected so that I can do the solution for you.

Shanker V

[Hi2023]

It wont let me post the file but the filename as listed in the previous response I posted and I want a new column names system to show the FGG out of that filename only

the other 3 I want to be out would be in the same file format

WAL

PACER

PPL

thanks

[Hi2023]

Filename (column)

D:\Users\123456\Downloads\JYC\Dups files\FGG\FOOOBasePhotoIngest_Upload_DTP_FGG_File1_2022-09-17 123456.xlsx

Output

System (new column)

FGG

[KrishnaChithrathil · Accepted solution]

@Hi2023 

There would definitely be a workaround for this. But for the time being you can try this. I donno how your other file paths look like. you can have this a try. please lemme know.

[KrishnaChithrathil]

@Hi2023 

Okay. I did a lil research and finally found this. 🙂

[Hi2023]

What if I need to get the Alert ID # only out of this column

Column name: Alert ID

EMM: total transactions - 1 and total amount - 8766.78; Inclearing: Total Transactions - 0 and Total Amount -0; EMM:Total Transactions -0 and Total Amount -0; FIRES: Total transactions -0 and Total Amount -0: Check Seroil #'s or Vlert ID's; 123456789; Ref Date(s) 2023-08-01 20:58:24;

expected outcome: new column name: AlertID POL

123456789