Find replace not replacing properly

i have 1 dataset with a column and a value

bear

i have a another find/replace dataset with word (as columns)

find: bear

replace: grizzly bear

when i look at the output it shows griz

why doesnt it do entire replacement, the configuration says "Place Found Text With Value: " and i select the 'replace' column in my dataset..

why would it only replace the word with the same amount of char in original? ive never seen a find/replace functionality do this (Word, Excel, Notepad, etc, etc)

if i change the word bear to bearr the replacement is then grizz, showing it uses the # of chars. can someone explain the behavior and how do i do a standard find/replace

Developer

Accepted answers

atcodedog05

Hi @MTS

This is a column size issue. Please a select tool before find and replace and increase size of the column. Since bear length for 4 the griz was taken of length 4.

All comments

atcodedog05

Hi @MTS

This is a column size issue. Please a select tool before find and replace and increase size of the column. Since bear length for 4 the griz was taken of length 4.

atcodedog05

Hi @MTS

Check is workflow out.

Hope this helps : )

find and replace.yxmd

MTS

thanks, my input data is from a Text Input tool. i am playing with the examples for the Find/Replace tool which is only a text Input tool as well, why are these fields size not limited. So the text input will auto-adjust its length based on the longest value in column and you need the select tool to create a standard default size?

are CVS files imported also limited by longest characters? is there a setting on import that removes that limitation? thanks

MTS

it actually explains this behavior in the example file for this tool..

another question... What if I want to find the value in the entire dataset and do a replacement? this tool only seems to have 1 column as a option... what tool would I need to do a full find/replace in entire dataset?

atcodedog05

Hi @MTS

@MTS wrote:
are CVS files imported also limited by longest characters? is there a setting on import that removes that limitation? thanks

Yes thats correct, its not only csv file any data which is inputted will be by default sized to length of the max length string. Hence if there is any manipulation on input field which would require a larger size a select tool would be needed before to increase the size.

Hope this helps : )

atcodedog05

Hi @MTS

@MTS wrote:
another question... What if I want to find the value in the entire dataset and do a replacement? this tool only seems to have 1 column as a option... what tool would I need to do a full find/replace in entire dataset?

There is no tool which replaces on the data level. Either you need to apply multiple times on columns or transpose the data apply and crosstab data

Landry

Thank you @atcodedog05 Was having the same issue and it's such an easy fix when you know the problem.

Seems like it's set up a bit backwards to not allow a text replacement to be longer than the original text; you would assume the column size would be updated to the replacement length.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703