Search String

[#1]

Hello All,

How are you?

I have a simple question this time.

I want to search the following strings from the right to find the price. The price value is concatenated with the item id in this manner.

Item_Price:

40637_123ABC_400

40644_1457_2300

40651_12_23005

So all values after the second "_" (underscore) is the price. And all the value before the first underscore "_" is the Julian date

So please suggest how to use the "Right" or Trim function.

Thanks in advance,

Bikash

[gussfish]

Hi Bikash,

the answer is that you don't want to use either function! Instead, use

subfield(str,'delimiter',n). This breaks-up the string str into

substrings at every occurence of 'delimiter', and returns the (n)th

substring.

So, in your example, you want subfield(Item_Price,'_',2).

Angus.

[#3 · Accepted solution]

Hi Angus,

Thank you very much.

I got it how the result would look like.

Thanks & Regards,

Bikash

[gussfish]

Hi Bikash,

my previous post assumed that your Item_Price would always have the same

number of underscores in it. If this is not the case, and you need to

find the remainder of the string after the last underscore, then use

index(Item_Price, '_', -1 ) to find the position of the last underscore;

then you can use mid() to extract from after that.

Angus.

[#5]

Angus

I have the above issue,

Can you please help ?

I have used the following to find each of the ',' , now I would like the text either side

index([Rejection Reasons], ',', -1 )

Can you offer guidence please ?

Thanks,
A

[#6]

Meant to say there are multiple ','

[jduenyas]

Try this:

Left part = mid([Rejection Reasons],1,index([Rejection Reasons],',',-1)-1)

Or  Left Part = left(([Rejection Reasons],index([Rejection Reasons],',',-1)-1)

Right part = mid([Rejection Reasons],index([Rejection Reasons],',',-1)+1,len([Rejection Reasons]))

[#8]

Thanks jduenyas