Mike, I have converted data strings of a variety of computer outputs.
If you get a continuous string, you need to determine where each file begins and ends. There is some type of marker in the string. If it is a carriage return/line feed it will be easier. If not, you can search and replace, The fields will likely be either fixed field lengths, or comma (or other symbol) delimited. If fixed field, you need to know the length of each field, and you can specify that characters 1-5 go in the first field, and 6-22 in the next, and so forth. Comma delimited should come in field order. You may have to remove ASCII characters that are not letters or numbers as they may be codes that will be "confusing" to the input gateway program. Vaguely I remember fields that did not "line up" properly. I moved subsequent rows in a spreadsheet to get what I wanted. R:Base has operations to (SGET( (SRPL( (SFIL( and other operations to adjust data. Gateway has an XML option. Hopefully your data will come in easily, and without a glitch. Sometimes using the gateway command from the command prompt will work even better than the Gateway icon. Let us know how it goes. Randy Peterson ________________________________ From: [email protected] <[email protected]> on behalf of Bruce Chitiea <[email protected]> Sent: Thursday, February 25, 2021 10:56 AM To: [email protected] <[email protected]> Subject: Re[2]: [EXT] Re: [RBASE-L] - Importing XML data into R:BASE Mike: Hey, I'm all for all of that. To that end, there may be a role for "data preparation" tools here. I have such a tool - "Monarch" (from Altair/DataWatch) - in which I am irresponsibly rusty, but have used to great effect in the past to convert PDF and tables captured from web sites into usable ASCII and .xlsx files for import to R:BASE. I'm due for a focused training, so if you send a sample, I'll give it a go. No promises, but if it works ... happy to help. Bruce A. Chitiea SafeSectors, Inc. ----------------------------------- 112 Harvard Ave #272 Claremont CA 91711-4716 USA ----------------------------------- [email protected] ----------------------------------- +011 (909) 238-9012 c +011 (909) 912-8678 f ------ Original Message ------ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: 2/25/2021 8:33:06 AM Subject: Re: [EXT] Re: [RBASE-L] - Importing XML data into R:BASE Thanks for the insight, Jan. I will have to approach it as a way to expand my data skills. As Mr. Memon says. "If you can dream it you can do it.". And "be sure to have fun". Be safe and healthy! Best regards. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: "jan johansen" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Date: 02/25/2021 11:08 AM Subject: [EXT] Re: [RBASE-L] - Importing XML data into R:BASE Sent by: [email protected]<mailto:[email protected]> ________________________________ Mike, I'm going out on a limb here. I'm not sure there is a standardized XML format so you kind of have to look at the data presented and see what you can do with it. In the past, I've run a cursor through some pretty weird data as an input routine. Good luck, Jan From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Date: Wed, 24 Feb 2021 10:12:50 -0500 Subject: [RBASE-L] - Importing XML data into R:BASE Greetings: I am tasked with importing a large amount of data in the XML format into R:BASE. I haven't worked with the XML format much yet. I would appreciate any suggestions on good learning resources that anyone in R:BASE World has used to enhance their XML skills. Thank you in advance. Have a safe and healthy day! Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/OF2087463D.4801D557-ON85258686.0052E6A4-85258686.005392CB%40aksteel.com<https://groups.google.com/d/msgid/rbase-l/OF2087463D.4801D557-ON85258686.0052E6A4-85258686.005392CB%40aksteel.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20210225160758.670060%40jjcalibrations.com<https://groups.google.com/d/msgid/rbase-l/WC20210225160758.670060%40jjcalibrations.com?utm_medium=email&utm_source=footer>. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/OF621FC0D8.FF92CC6B-ON85258687.00595EFF-85258687.005AEC13%40aksteel.com<https://groups.google.com/d/msgid/rbase-l/OF621FC0D8.FF92CC6B-ON85258687.00595EFF-85258687.005AEC13%40aksteel.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em410519b2-a1b3-4748-946b-aed5ca6b8d2e%40pathfinder<https://groups.google.com/d/msgid/rbase-l/em410519b2-a1b3-4748-946b-aed5ca6b8d2e%40pathfinder?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR11MB1512E7BF5ED324AE0342C83CC79E9%40CY4PR11MB1512.namprd11.prod.outlook.com.
