-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Products and Technology
- Product Lifecycle Management
- PLM Q&A
- parse flat file in MII
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
parse flat file in MII
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on ‎2017 Mar 11 7:41 AM
- SAP Managed Tags
- SAP Manufacturing Integration and Intelligence
Hi folks, I got flat file having no delimiters, that is fixed positions are assigned to the columns. There is also no end of line characteristic besides "carriage return".
I am wondering if there is any way of parsing this besides usnig string functions? I tried to use advanced flat file parser but I do not have an EOL character. So I tried to somehow manage to use "carriage return" using base64 encoding..no success.
String functions is the only way here? Any ideas?
Thx for your suggestions
Know the answer?
Help others by sharing your knowledge.
AnswerNeed more details?
Request clarification before answering.
Accepted Solutions (1)
Accepted Solutions (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Personally I would try to do it with an xsl transform.
Regards,
Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answers (3)
Answers (3)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Good point Christian, it is working fine!
Thx Marco
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Swaroop, plz find below a sample. Those files can be very long what is why I don't like the idea of using string functions. Greetings, marco
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marco,
Can you put a sample of you file here to see if we have any ideas.
Regards,
Swaroop
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky- SAP HANA cloud flat file import Chinese langauge(Description column in file) in Product Lifecycle Management Q&A
- Read Idoc error in Product Lifecycle Management Q&A
- Automate data load from Flat file into SAP HANA in Product Lifecycle Management Q&A
- SAP OEE - Production Order tables in Product Lifecycle Management Q&A
- Support for managing order change requests, semi-automatic in Product Lifecycle Management Q&A
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.