Excel find/replace activites changing string to integer

Help Activities
, ,
1

Hello, I want to change strings to codes(also string) like these inside B column:
“IIM” => “0021”, “IKL” => “0010”
However after find/replace value activites it goes like “IIM” => “21”.

My sequence:

image
image1083×774 33.8 KB

I tried these so far:

  • I added a format cells before replace acitivites to ensure column in string format. It didn’t work. I double checked the result excel, column type is set to string.

  • I log my codes to see if they are string or not. They are string in the logs.

I can add “00” to someone but this will not solve all my problem since some codes are like this “0126”. Still I can check the lenght then add “0” accordingly but it is already takes a lot of time.

What am I missing? Thank you for your help!

1 Like
2

Hi @Baris_Kilinc

Place the single quote at front of the text like this 'IIM.

Hope it helps!!

3

Thank you for your response however:

I don’t understand where I should add single quote and how it will change the outcome. I don’t have trouble with the finding the string like “IIm”. The replaced value types change to int.

4

Okay @Baris_Kilinc , In replace field give like this

"'"+CurrentRow.Item(1).toString

Hope it helps!!

5

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