How to split each element of a string array into different categories?

Question

I am using node.js to fetch data from a website. Once I have that fetched data I want to insert into a mySQL database. Fetching the the url gives me a json dump of information. After formatting the string, I am using an array to store my data. Below is an example of my output: I want to split each

Accepted Answer

@TayshawnHill … was this already sufficient enough?… version 1 matches/captures exactly the pts_time like formats/categories whereas version 2 matches/captures the more generic formats/categories. – Peter Seliger@PeterSeliger version 2 groups them how I would like them. However, I am not sure how to make use of the regex to put the parameter, value, and description into an object. – Tayshawn Hill… here we go … function createKeyValueAndDescriptionList(pattern) { const regXCompositeValue = (/^(?[^:]+):s*(?:(?[A-Za-z]+:s*[^>]+))s*(?.*)/); const regXGenericValue = (/^(?[^:]+):s*(?[w']+(?:s*([^)]*))*)s*(?.*)/); const { groups } = ( regXCompositeValue.exec(pattern) || regXGenericValue.exec(pattern) || {} ); return (groups && [ groups.key, groups.value.trim(), groups.description || '', ] || []);}console.log([ 'table_id: 0xFC (252) SCTE 35', "section_syntax_indicator: '0'", "private_indicator: '0'", "reserved: '11'", 'section_length: 0x39 (57)', 'protocol_version: 0', 'encrypted_packet: 0 no part of this message is encrypted', 'encryption_algorithm: 0 No encryption', 'pts_adjustment: 0xFFFF7F18 (33000) > Time: 95443.4 sec > (hh:mm:ss.ms) 26:30:43.351', 'cw_index: 0x00 (0)', 'tier: 0x0FFF (4095)', 'splice_command_length: 0x0005 (5)', 'splice_command_type: 0x06 (6) time_signal [] time_signal: > Time: 19345 sec > (hh:mm:ss.ms) 05:22:24.972', 'time_specified_flag: 1 presence of the pts_time field', 'reserved: 0x3F (63)', 'pts_time: PTS: 1741047514 [0x67C646DA] > Time: 19345 sec > (hh:mm:ss.ms) 05:22:24.972', 'descriptor_loop_length: 35 [] Descriptors: [] segmentation_descriptor (0x02): Content Identification (0x01)', 'descriptor_tag: 0x02 (2)', 'descriptor_length: 0x21 (33)', 'identifier: 0x43554549 (CUEI)', 'segmentation_event_id: 0x00000001 (1)', "segmentation_event_cancel_indicator: '0' a previously sent segmentation event, identified by segmentation_event_id, has NOT been cancelled", 'reserved: 0x7F (127)', "program_segmentation_flag: '1' the message refers to a Program Segmentation Point and that the mode is the Program Segmentation Mode whereby all PIDs/components of the program are to be segmented", "segmentation_duration_flag: '0' No presence of segmentation_duration field", "delivery_not_restricted_flag: '1' the next five bits are reserved", 'reserved: 0x1F (31)', 'segmentation_upid_type: 0x01 (1) Deprecated: use type 0x0C; The segmentation_upid does not follow a standard naming scheme.', 'segmentation_upid_length: 0x12 (18)', 'segmentation_type_id: 0x01 (1) Content Identification', 'segment_num: 0x01 (1)', 'segments_expected: 0x01 (1)', 'CRC_32: 0x46D15AF3 CRC OK',].map(createKeyValueAndDescriptionList));console.log([ "foo:------------", "bar:++++++++++++", "baz:############",].map(createKeyValueAndDescriptionList)); .as-console-wrapper { min-height: 100%!important; top: 0; }

Advertisement

Answer