I need to create a column XXX where i should get the Number/text between the text. KeepChar(name, '0123456789') worked for 2 scenarios and i need to apply for the other one too. i...
Hi, I have this in my script right now and it is working. TextBetween(Description, 'JHI_', ' - ') as Abbreviations What I'd like to do is say TextBetween(Description, 'J...
COLUMN A CN=SUPPORT,DC=TOMKINS,DC=NET CN=Operations Manager ,DC=na,DC=corp Hi Friends, I need help in using TextBetween. I have a column as Column A. I would like to extract n...
How do I set the text between to find the first occurrence of a value and the last occurrence of another value? TextBetween(FIELD,'(',')') is what I am needing but I want it to get all the t...
Bonjour, Comment pourrai je utiliser textbetween pour prendre que 4chiffres de l'attribut suivant TextBetween Date(Date#(ADDTEN, 'DDMYYYY'), 'YYYY') c'est à dire je dois supprimer le 1er chiffre e...
...ield2 Field3 Help Me FindThis Help Me GetThis Get This Data Get This I've been trying nested IF's using TextBetween and have gotten good results, but still can't get 100% of the d...
...ntries which has '_ 'and '.' . So I used TextBetween function. But it is not giving me for all. Please help me to get only NAME from all the given possibilities of name entries. I tried t...
Hi, I have 2 tables with the join Table1.Substring (col1,1,4) = Table2.ID. I am writing MID in the load statement for table 1 as: Load MID (col1,1,4) AS ID. Would this join work? Because ...
Hello guys, I am using a textbetween function to extract some string from an xml that is stored in a one of the columns in my db2 table. This is what the data looks like. I am e...
Hi, I'm trying to load only the text AAA, BBB, CCC from the example below: This exaple is one line in a web page ! I use textbetween function but it returns me only the AAA value , the BBB and C...
