Hello, I'm looking for solution to extract specific part of data
The data in my column looks like this (below)
20xx-10-31SPR10F/000000/3Spr.00000/10/00/01/FF
20xx-11-07S10/000001/3sometext
etc.
And I want to take out this "00000/10/00/01/FF" part form the first line if there is "Spr." word and if not the formula should take this part "S10/000001/3sometext"
I wrote something like this " if FindString([data_column], 'Spr.') then Right([data_column], 17) else Substring([data_column], 10) endif " but I only receive the 17 digits from right
Could you tell me what I'm doing wrong ?
Thanks !
Solved! Go to Solution.
@Wojtek_Dz
You mean take out, right? so you need to add Replace formula I think.
Hey Qiu thanks for your answer.
But unfortunately your solution is not what I was looking for
For column with this dataset:
20xx-10-31SPR10F/000000/3Spr.00000/10/00/01/FF
20xx-11-07S10/000001/3sometext
I want to take out this parts to new column:
00000/10/00/01/FF
S10/000001/3sometext
Thanks !
@Wojtek_Dz
I come to know the problem here.
The FindString function is returing the numeric position of the target string, while not a true or false.
So you condistion statement always goes to true branch.
Now modified the worksflow as attached.
Appreicate if you could mark it as accepted.
Thanks, now it works.
Greetings 🙌