on 08-10-2007 6:55 AM
Hi All,
I am working on a file to RFC scenario in which am uploading the swipe in/out details of employees into SAP. The data from the recording machine comes as a file.
The problem is that, at different plants they have differnt make of time recording machines which gives data in different formats as below:
000003253 07080623550003 - format from plant1
000000115 2007080707041607 - format from plant2
000036273 07080706321 01 - format from plant 3
The first 9 digits - emp no, then a space
first 6(in first and third format)8 (in second format )digits in the second string - date
next 4 digits hours and minutes
next digit - if 1 - time in
if 0 - timeout
last 3 - ID of the time capturing machine
I was able to manipulate the first two formats in mapping itself. The problem is the third format which has a space in it.
Thanks and Regards
Arun
.
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
Can you tell me the logic you have applied,
I'll reply accordingly....
If you are doing a simple FCC with two nodes, one for Emp No, and next node for the combination of rest, then this can be achieved with a simple UDF.
The second node can be split in2 date, time, timein.out and ID based on an if condition
This spit can be trimmed to remove the spaces..
Pl temme if u need more clarification
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.