Looking for a specific word in a database row

Help Studio
, ,
1

Hi all,

I have a row with a long information all together, but I just need to extract the ‘’ L ‘’. Because IF there’s a ,L, I want the IF condition to do one thing, IF there is no ,L, I want to do another action.

I can’t put the whole information as there’s confidential information but:

image

On my conditional I stated as below. But the outcome is ‘’ 30 ‘’ instead of ‘’ L ‘’ and does not go to my THEN, but to my ELSE…

image

Thank you!

2

Hello @Ruy_Codo

May I know are you looking for a specific value in a single row .? or you want to check the same value into all rows .?

3

Hi @Shaik_Najeer ,

Thank you so much for this reply. So when there’s the letter L, I want my IF condition to go through it. If there’s no ,L, I want to go to another way.
The problem is my code is not reading the ‘’ L ‘’, only the number 30 as it is the first thing to be on the row.
But I have a for each code above to access this transaction.

4

According to me when you are trying to read the cell which contains data starting with 30 is producing only 30 without remaining string.

if yes try to use read cell activity then use if condition.

if not please try to give some other explanation that could help me to understand thoroughly.

Thanks.

5

@Ruy_Codo

Is that a csv file?

Cheers

6

@Shaik_Najeer @Anil_G : Thank you for the help.

Let me explain in a better way: I have a Data Table where I extracted all information from a specific transaction on SAP and I store on this data table.

image

Later, I added a For Each activity because I want to check all rows and add prices, vendors, etc.
image

On this For Each, I will access a new transaction to check if the raw material has a global contract. In case the Global Contract on the transaction is cancelled, it brings the letter ‘’ L ‘’. This information I’m pulling directly from SAP and storing on a new Data Table I created just to store if the material has a global contract or not.

But when I do the formula below, it only caught the number ‘’ 30 ‘’ as it is the first figure to appear on the row…

image

I hope I could put it across in a better way! Thank you for your time and help.

7

@Ruy_Codo

Can you please add a break point after extraction and then open locals panel and check the data in datatable…I beleive the first column contains only 30 and it does not have any other info…or other columns might be having…please check and accordingly use the column…

Cheers

8

@Anil_G - I did that. Indeed the information is all together as I printscreen above. I thought too I made a mistake somehow but not, it is all together.

image

9

@Ruy_Codo

But as per your previous comment you said that it is only getting 30…and nothign else…

So in log messge with item(0) is giving only 30 but you have all data in that cell?

Cheers

10

@Anil_G Exactly… Only getting when I put a log message.

11

@Ruy_Codo

In log message if you are getting only 30 then that cell apparently has only 30 in it…may be the next colum. Is having data

Cheers

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.