![Splitting String in Informatica with Delimiter issues-after-qlikview-version-upgrade-on-passive-node-of-production-servers](https://www.s-squaresystems.com/wp-content/uploads/Splitting-String-in-Informatica-with-Delimiter.png)
Source Analyzer:
Step 1: Go to tools menu select source menu select Source analyser files from source menu.
-
-
- Import source data from Database.
-
![Picture72](https://www.s-squaresystems.com/wp-content/uploads/Picture72.png)
Target:
Step 2: Go to tools menu select target menu select target files from target menu.
-
-
- Import Target data from file (.csv or .txt) location or Create the file if no flat file exists.
-
![Picture73](https://www.s-squaresystems.com/wp-content/uploads/Picture73.png)
Mapping:
Create Mapping with respective name (e.g.:m_mailsplit), m_ is naming convention for mapping creation.
Variable ports:
To identify delimiter (A delimiter is one or more characters that separate text strings i.e.’@’,’.’,’#’) in the string, we have to create variable ports by using Expression Transformation.
Variable1 Logic:
SUBSTR(EMP_EMAIL,1,INSTR(EMP_EMAIL,’@’,1)-1)
Use the above logic in the Expression transformation in variable port and assign as an out port.
![Picture74](https://www.s-squaresystems.com/wp-content/uploads/Picture74.png)
Variable2 Logic:
SUBSTR(EMP_EMAIL,INSTR(EMP_EMAIL,’@’,1)+1,IIF(INSTR(EMP_EMAIL,’@’,1,2)=0,LENGTH(EMP_EMAIL),(INSTR(EMP_EMAIL,’@’,1,2)-INSTR(EMP_EMAIL,’@’,1,1)-1)))
Use the above logic in the Expression transformation in variable port and assign as an out port.
![Picture75](https://www.s-squaresystems.com/wp-content/uploads/Picture75.png)
Save the mapping.
Workflow Manager:
Workflow:
Go to Workflow manager à to create workflow and session for mapping process.
Session:
Go to Workflow manager à to create task for session in mapping process.
Create a link between session and worklet as shown in below screenshot. Save the workflow designer.
![Picture76](https://www.s-squaresystems.com/wp-content/uploads/Picture76.png)
Save Work flow and Right click on Session for getting Work flow monitor for output details ,as shown below.
OUT PUT:
Please find the below screenshot for Source data with delimiter.
![Picture77](https://www.s-squaresystems.com/wp-content/uploads/Picture77.png)
Please find the below Screen shot for Flat file generated without delimiter.